07 7월

oracle : move & relocate dbf datafile Hint

Manual Online

SQL> SELECT name FROM v$datafile WHERE name LIKE '%test%';

SQL> ALTER TABLESPACE test OFFLINE NORMAL;

SQL> HOST mv /oracle0/test0.dbf /oracle1/test1.dbf

SQL> ALTER TABLESPACE test RENAME DATAFILE '/oracle0/test0.dbf' TO '/oracle1/test1.dbf';

SQL> ALTER TABLESPACE test ONLINE;

SQL> SELECT name FROM v$datafile;

SQL> SHUTDOWN IMMEDIATE

 

Manual Offline

SQL> HOST MOVE /oracle0/test0.dbf /oracle1/test1.dbf 

SQL> STARTUP MOUNT

SQL> ALTER DATABASE RENAME FILE '/oracle0/test0.dbf' to '/oracle1/test1.dbf';

SQL> ALTER DATABASE OPEN;

 

 

 

 

 

by